﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetAllDepartamentos')
	BEGIN
		PRINT 'DROP  Procedure  GetAllDepartamentos'
		DROP  Procedure  GetAllDepartamentos
	END
GO

PRINT 'CREATE Procedure GetAllDepartamentos'
GO

CREATE Procedure GetAllDepartamentos

AS

BEGIN

	SELECT DISTINCT(IdDepartamento),Departamento FROM UBIGEO

END

GO


GRANT EXEC ON GetAllDepartamentos TO PUBLIC

GO

